package com.spring.shops.dao;

import com.spring.shops.model.entity.TzTransport;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TzTransportMapper {

    @Select("select * from tz_transport limit #{param1},#{param2}")
    List<TzTransport> selectTransportPage(int start, int size);

    @Select("select count(*) from tz_transport")
    int selectCount();

    //    @Select("select * from tz_transport where trans_name like '%#{param}%'")
    List<TzTransport> selectByLike(String transName);

    int deleteByPrimaryKey(Long transportId);

    int insert(TzTransport record);

    int insertSelective(TzTransport record);

    TzTransport selectByPrimaryKey(Long transportId);

    int updateByPrimaryKeySelective(TzTransport record);

    int updateByPrimaryKey(TzTransport tzTransport);
    @Select("select * from yami_shops.tz_transport")
    List<TzTransport> listAllTransport();
}